Importing and exporting CSV files.

Importing entries from a CSV file.

To import data from CSV files, do the following: :
  1. Copy the file you want to import to the memento folder on the flash card.
  2. Open the library you want to import the entries to.
  3. Select the Settings item on the library menu.
  4. Press Import from CSV in the settings. You will see the list of CSV files in the memento folder. Select the one you need.
  5. After you select the file, you will see the list of columns found in the file which correspond to the entry fields.
  6. Press the Import button.
When you import data from CSV files, new entries are created each time.

CSV file format.

The name of a column must correspond to the name of an entry field.
The file must contain a column with the field that is the name of the entry.

Memento allows you to import only fields of certain types: text, integer, real number, date, date/time, rating, currency, string values, coordinate, boolean, hyperlink.

Data format notes:
Field type Format and notes
Date The date must be in the same format as in the system settings.
Date/Time The values are separated with a space, the date comes first and then comes time in the HH:MM format.
String values The value being imported must already be in the parameters of the corresponding field.
Boolean The following values are acceptable for the truth value: true, yes, 1
Coordinate latitude:longitude
Rating A number from 0 to 5.

Before you import entries, it is recommended to back up your libraries.

Exporting data to CSV

To export data to a CSV file, do the following:
  1. Open the library you want to export entries to a CSV file from.
  2. Select the Settings item on the library menu.
  3. Press Export to CSV in the settings.
  4. Enter the name of the CSV file and press the Export button.
  5. The file with data will be saved to the memento folder on the flash card.